Pandas Profiling Report

Dataset statistics

Number of variables	44
Number of observations	115037
Missing cells	171246
Missing cells (%)	3.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	38.6 MiB
Average record size in memory	352.0 B

Variable types

Categorical	25
Numeric	19

Alerts

`order_id` has a high cardinality: 96036 distinct values	High cardinality
`customer_id` has a high cardinality: 96036 distinct values	High cardinality
`order_purchase_timestamp` has a high cardinality: 95515 distinct values	High cardinality
`order_approved_at` has a high cardinality: 87916 distinct values	High cardinality
`order_delivered_carrier_date` has a high cardinality: 78867 distinct values	High cardinality
`order_delivered_customer_date` has a high cardinality: 93239 distinct values	High cardinality
`order_estimated_delivery_date` has a high cardinality: 449 distinct values	High cardinality
`product_id` has a high cardinality: 32063 distinct values	High cardinality
`seller_id` has a high cardinality: 3021 distinct values	High cardinality
`shipping_limit_date` has a high cardinality: 90958 distinct values	High cardinality
`seller_city` has a high cardinality: 604 distinct values	High cardinality
`customer_unique_id` has a high cardinality: 92939 distinct values	High cardinality
`customer_city` has a high cardinality: 4044 distinct values	High cardinality
`product_category_name` has a high cardinality: 71 distinct values	High cardinality
`product_category_name_english` has a high cardinality: 71 distinct values	High cardinality
`review_id` has a high cardinality: 95840 distinct values	High cardinality
`review_comment_title` has a high cardinality: 4455 distinct values	High cardinality
`review_comment_message` has a high cardinality: 35020 distinct values	High cardinality
`review_creation_date` has a high cardinality: 632 distinct values	High cardinality
`review_answer_timestamp` has a high cardinality: 95685 distinct values	High cardinality
`price` is highly correlated with `product_weight_g` and 1 other fields	High correlation
`product_weight_g` is highly correlated with `price` and 3 other fields	High correlation
`product_length_cm` is highly correlated with `product_weight_g` and 1 other fields	High correlation
`product_height_cm` is highly correlated with `product_weight_g`	High correlation
`product_width_cm` is highly correlated with `product_weight_g` and 1 other fields	High correlation
`payment_value` is highly correlated with `price`	High correlation
`price` is highly correlated with `payment_value`	High correlation
`freight_value` is highly correlated with `product_weight_g`	High correlation
`product_weight_g` is highly correlated with `freight_value` and 2 other fields	High correlation
`product_length_cm` is highly correlated with `product_width_cm`	High correlation
`product_height_cm` is highly correlated with `product_weight_g`	High correlation
`product_width_cm` is highly correlated with `product_weight_g` and 1 other fields	High correlation
`payment_value` is highly correlated with `price`	High correlation
`price` is highly correlated with `payment_value`	High correlation
`payment_value` is highly correlated with `price`	High correlation
`product_category_name` is highly correlated with `product_category_name_english`	High correlation
`product_category_name_english` is highly correlated with `product_category_name`	High correlation
`price` is highly correlated with `payment_value`	High correlation
`seller_zip_code_prefix` is highly correlated with `seller_state` and 4 other fields	High correlation
`seller_state` is highly correlated with `seller_zip_code_prefix` and 4 other fields	High correlation
`customer_zip_code_prefix` is highly correlated with `customer_state` and 2 other fields	High correlation
`customer_state` is highly correlated with `customer_zip_code_prefix` and 2 other fields	High correlation
`product_category_name` is highly correlated with `seller_zip_code_prefix` and 9 other fields	High correlation
`product_description_lenght` is highly correlated with `product_category_name` and 1 other fields	High correlation
`product_weight_g` is highly correlated with `product_category_name` and 1 other fields	High correlation
`product_length_cm` is highly correlated with `product_category_name` and 2 other fields	High correlation
`product_height_cm` is highly correlated with `product_category_name` and 1 other fields	High correlation
`product_width_cm` is highly correlated with `product_category_name` and 2 other fields	High correlation
`payment_value` is highly correlated with `price`	High correlation
`product_category_name_english` is highly correlated with `seller_zip_code_prefix` and 9 other fields	High correlation
`geolocation_lat_customer` is highly correlated with `customer_zip_code_prefix` and 2 other fields	High correlation
`geolocation_lng_customer` is highly correlated with `customer_zip_code_prefix` and 2 other fields	High correlation
`geolocation_lat_seller` is highly correlated with `seller_zip_code_prefix` and 4 other fields	High correlation
`geolocation_lng_seller` is highly correlated with `seller_zip_code_prefix` and 4 other fields	High correlation
`order_delivered_carrier_date` has 1185 (1.0%) missing values	Missing
`order_delivered_customer_date` has 2384 (2.1%) missing values	Missing
`review_comment_title` has 101302 (88.1%) missing values	Missing
`review_comment_message` has 66357 (57.7%) missing values	Missing
`order_id` is uniformly distributed	Uniform
`customer_id` is uniformly distributed	Uniform
`order_purchase_timestamp` is uniformly distributed	Uniform
`order_approved_at` is uniformly distributed	Uniform
`order_delivered_customer_date` is uniformly distributed	Uniform
`shipping_limit_date` is uniformly distributed	Uniform
`customer_unique_id` is uniformly distributed	Uniform
`review_id` is uniformly distributed	Uniform
`review_answer_timestamp` is uniformly distributed	Uniform

Reproduction

Analysis started	2022-04-06 15:19:26.999147
Analysis finished	2022-04-06 15:21:52.952512
Duration	2 minutes and 25.95 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

order_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	96036
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

895ab968e7bb0d5659d16cd74cd1650c	63
fedcd9f7ccdc8cba3a18defedd1a5547	38
fa65dad1b0e818e3ccc5cb0e39231352	29
ccf804e764ed5650cd8759557269dc13	26
465c2e1bee4561cb39e0db8c5993aafc	24
Other values (96031)	114857

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83510 ?
Unique (%)	72.6%

Sample

1st row	e481f51cbdc54678b7cc49136f2d6af7
2nd row	e481f51cbdc54678b7cc49136f2d6af7
3rd row	e481f51cbdc54678b7cc49136f2d6af7
4th row	128e10d95713541c87cd1a2e48201934
5th row	0e7e841ddf8f8f2de2bad69267ecfbcf

Common Values

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
fa65dad1b0e818e3ccc5cb0e39231352	29	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
5a3b1c29a49756e75f1ef513383c0c12	22	< 0.1%
Other values (96026)	114739	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
fa65dad1b0e818e3ccc5cb0e39231352	29	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
5a3b1c29a49756e75f1ef513383c0c12	22	< 0.1%
Other values (96026)	114739	99.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	96036
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

270c23a11d024a44c896d1894b261a83	63
13aa59158da63ba0e93ec6ac2c07aacb	38
9af2372a1e49340278e7c1ef8d749f34	29
92cd3ec6e2d643d4ebd0e3d6238f69e2	26
63b964e79dee32a3587651701a2b8dbf	24
Other values (96031)	114857

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83510 ?
Unique (%)	72.6%

Sample

1st row	9ef432eb6251297304e76186b10a928d
2nd row	9ef432eb6251297304e76186b10a928d
3rd row	9ef432eb6251297304e76186b10a928d
4th row	a20e8105f23924cd00833fd87daa0831
5th row	26c7ac168e1433912a51b924fbd34d34

Common Values

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
9af2372a1e49340278e7c1ef8d749f34	29	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f2	22	< 0.1%
Other values (96026)	114739	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
9af2372a1e49340278e7c1ef8d749f34	29	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f2	22	< 0.1%
Other values (96026)	114739	99.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_status
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

delivered	112654
shipped	1132
canceled	530
processing	356
invoiced	355
Other values (2)	10

Length

Max length	11
Median length	9
Mean length	8.975816476
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	112654	97.9%
shipped	1132	1.0%
canceled	530	0.5%
processing	356	0.3%
invoiced	355	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
delivered	112654	97.9%
shipped	1132	1.0%
canceled	530	0.5%
processing	356	0.3%
invoiced	355	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_purchase_timestamp
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	95515
Distinct (%)	83.0%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

2017-08-08 20:26:31	63
2017-09-23 14:56:45	38
2017-04-20 12:45:34	29
2017-06-07 12:05:10	26
2017-03-09 23:39:26	24
Other values (95510)	114857

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82735 ?
Unique (%)	71.9%

Sample

1st row	2017-10-02 10:56:33
2nd row	2017-10-02 10:56:33
3rd row	2017-10-02 10:56:33
4th row	2017-08-15 18:29:31
5th row	2017-08-02 18:24:47

Common Values

Value	Count	Frequency (%)
2017-08-08 20:26:31	63	0.1%
2017-09-23 14:56:45	38	< 0.1%
2017-04-20 12:45:34	29	< 0.1%
2017-06-07 12:05:10	26	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2018-05-12 12:28:58	24	< 0.1%
2017-07-07 14:55:43	24	< 0.1%
2017-11-25 13:54:39	24	< 0.1%
2018-02-14 16:34:27	24	< 0.1%
2017-12-08 12:00:04	22	< 0.1%
Other values (95505)	114739	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-24	1394	0.6%
2017-11-25	621	0.3%
2017-11-27	491	0.2%
2017-11-26	467	0.2%
2018-08-06	441	0.2%
2017-11-28	438	0.2%
2018-08-07	433	0.2%
2018-05-15	432	0.2%
2018-05-07	422	0.2%
2018-05-14	420	0.2%
Other values (50661)	224515	97.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_approved_at
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	87916
Distinct (%)	76.4%
Missing	14
Missing (%)	< 0.1%
Memory size	898.9 KiB

2017-08-08 20:43:31	63
2017-09-25 17:44:41	38
2017-04-22 09:10:13	29
2017-06-09 16:15:08	26
2017-07-07 15:10:17	24
Other values (87911)	114843

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70486 ?
Unique (%)	61.3%

Sample

1st row	2017-10-02 11:07:15
2nd row	2017-10-02 11:07:15
3rd row	2017-10-02 11:07:15
4th row	2017-08-15 20:05:16
5th row	2017-08-02 18:43:15

Common Values

Value	Count	Frequency (%)
2017-08-08 20:43:31	63	0.1%
2017-09-25 17:44:41	38	< 0.1%
2017-04-22 09:10:13	29	< 0.1%
2017-06-09 16:15:08	26	< 0.1%
2017-07-07 15:10:17	24	< 0.1%
2018-05-12 15:41:58	24	< 0.1%
2017-03-09 23:39:26	24	< 0.1%
2018-02-21 12:28:15	24	< 0.1%
2017-11-25 14:16:34	24	< 0.1%
2018-02-24 03:20:27	23	< 0.1%
Other values (87906)	114724	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-04-24	1140	0.5%
2017-11-24	974	0.4%
2017-11-25	910	0.4%
2018-07-05	814	0.4%
2017-11-28	586	0.3%
2018-08-07	500	0.2%
2018-05-08	487	0.2%
2018-08-20	480	0.2%
2018-05-01	477	0.2%
2017-12-05	467	0.2%
Other values (41645)	223211	97.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_delivered_carrier_date
Categorical

HIGH CARDINALITY
MISSING

Distinct	78867
Distinct (%)	69.3%
Missing	1185
Missing (%)	1.0%
Memory size	898.9 KiB

2017-08-10 11:58:14	63
2018-05-09 15:48:00	48
2017-10-02 23:47:54	38
2018-05-10 18:29:00	35
2018-05-14 14:25:00	32
Other values (78862)	113636

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	59777 ?
Unique (%)	52.5%

Sample

1st row	2017-10-04 19:55:00
2nd row	2017-10-04 19:55:00
3rd row	2017-10-04 19:55:00
4th row	2017-08-17 15:28:33
5th row	2017-08-04 17:35:43

Common Values

Value	Count	Frequency (%)
2017-08-10 11:58:14	63	0.1%
2018-05-09 15:48:00	48	< 0.1%
2017-10-02 23:47:54	38	< 0.1%
2018-05-10 18:29:00	35	< 0.1%
2018-05-14 14:25:00	32	< 0.1%
2018-05-04 15:46:00	29	< 0.1%
2017-04-24 11:31:17	29	< 0.1%
2018-08-08 15:01:00	27	< 0.1%
2017-06-16 15:50:28	26	< 0.1%
2017-03-15 11:16:33	24	< 0.1%
Other values (78857)	113501	98.7%
(Missing)	1185	1.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-28	908	0.4%
2017-11-27	789	0.3%
2017-11-29	691	0.3%
2018-02-27	611	0.3%
2018-03-27	608	0.3%
2018-08-06	588	0.3%
2017-11-30	565	0.2%
2018-05-14	562	0.2%
2018-08-13	542	0.2%
2018-05-03	532	0.2%
Other values (36934)	221308	97.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_delivered_customer_date
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	93239
Distinct (%)	82.8%
Missing	2384
Missing (%)	2.1%
Memory size	898.9 KiB

2017-08-14 12:46:18	63
2017-10-18 22:35:50	38
2017-06-22 16:04:46	26
2017-03-21 13:32:45	24
2018-06-01 15:18:45	24
Other values (93234)	112478

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	80365 ?
Unique (%)	71.3%

Sample

1st row	2017-10-10 21:25:13
2nd row	2017-10-10 21:25:13
3rd row	2017-10-10 21:25:13
4th row	2017-08-18 14:44:43
5th row	2017-08-07 18:30:01

Common Values

Value	Count	Frequency (%)
2017-08-14 12:46:18	63	0.1%
2017-10-18 22:35:50	38	< 0.1%
2017-06-22 16:04:46	26	< 0.1%
2017-03-21 13:32:45	24	< 0.1%
2018-06-01 15:18:45	24	< 0.1%
2018-02-28 20:09:19	24	< 0.1%
2017-11-30 14:59:18	24	< 0.1%
2017-07-27 20:52:15	24	< 0.1%
2017-10-22 14:43:54	22	< 0.1%
2017-12-21 16:33:10	22	< 0.1%
Other values (93229)	112362	97.7%
(Missing)	2384	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-21	520	0.2%
2018-05-14	518	0.2%
2018-08-13	502	0.2%
2018-05-18	497	0.2%
2018-08-27	496	0.2%
2018-05-03	488	0.2%
2018-04-11	481	0.2%
2018-08-23	477	0.2%
2017-12-11	477	0.2%
2018-04-30	475	0.2%
Other values (41214)	220375	97.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_estimated_delivery_date
Categorical

HIGH CARDINALITY

Distinct	449
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

2017-12-20 00:00:00	644
2018-03-12 00:00:00	602
2018-05-29 00:00:00	596
2018-03-13 00:00:00	593
2018-07-16 00:00:00	586
Other values (444)	112016

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	< 0.1%

Sample

1st row	2017-10-18 00:00:00
2nd row	2017-10-18 00:00:00
3rd row	2017-10-18 00:00:00
4th row	2017-08-28 00:00:00
5th row	2017-08-15 00:00:00

Common Values

Value	Count	Frequency (%)
2017-12-20 00:00:00	644	0.6%
2018-03-12 00:00:00	602	0.5%
2018-05-29 00:00:00	596	0.5%
2018-03-13 00:00:00	593	0.5%
2018-07-16 00:00:00	586	0.5%
2018-07-05 00:00:00	582	0.5%
2018-05-28 00:00:00	576	0.5%
2018-05-30 00:00:00	575	0.5%
2018-02-14 00:00:00	570	0.5%
2017-12-19 00:00:00	564	0.5%
Other values (439)	109149	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	115037	50.0%
2017-12-20	644	0.3%
2018-03-12	602	0.3%
2018-05-29	596	0.3%
2018-03-13	593	0.3%
2018-07-16	586	0.3%
2018-07-05	582	0.3%
2018-05-28	576	0.3%
2018-05-30	575	0.2%
2018-02-14	570	0.2%
Other values (440)	109713	47.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

order_item_id
Real number (ℝ_≥0)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.194685188

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6866861517
Coefficient of variation (CV)	0.5747841846
Kurtosis	93.45279755
Mean	1.194685188
Median Absolute Deviation (MAD)	0
Skewness	7.198477309
Sum	137433
Variance	0.471537871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	100838	87.7%
2	10000	8.7%
3	2318	2.0%
4	964	0.8%
5	456	0.4%
6	256	0.2%
7	60	0.1%
8	35	< 0.1%
9	28	< 0.1%
10	25	< 0.1%
Other values (11)	57	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	100838	87.7%
2	10000	8.7%
3	2318	2.0%
4	964	0.8%
5	456	0.4%
6	256	0.2%
7	60	0.1%
8	35	< 0.1%
9	28	< 0.1%
10	25	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	2	< 0.1%
19	2	< 0.1%
18	2	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	4	< 0.1%
14	6	< 0.1%
13	7	< 0.1%
12	12	< 0.1%

product_id
Categorical

HIGH CARDINALITY

Distinct	32063
Distinct (%)	27.9%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

aca2eb7d00ea1a7b8ebd4e68314663af	531
99a4788cb24856965c36a24e339b6058	516
422879e10f46682990de24d770e7f83d	506
389d119b48cf3043d311335e499d9c6b	404
368c6c730842d78016ad823897a372db	392
Other values (32058)	112688

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16892 ?
Unique (%)	14.7%

Sample

1st row	87285b34884572647811a353c7ac498a
2nd row	87285b34884572647811a353c7ac498a
3rd row	87285b34884572647811a353c7ac498a
4th row	87285b34884572647811a353c7ac498a
5th row	87285b34884572647811a353c7ac498a

Common Values

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	531	0.5%
99a4788cb24856965c36a24e339b6058	516	0.4%
422879e10f46682990de24d770e7f83d	506	0.4%
389d119b48cf3043d311335e499d9c6b	404	0.4%
368c6c730842d78016ad823897a372db	392	0.3%
53759a2ecddad2bb87a079a1f1519f73	389	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	353	0.3%
53b36df67ebb7c41585e8d54d6772e08	323	0.3%
154e7e31ebfa092203795c972e5804a6	291	0.3%
3dd2a17168ec895c781a9191c1e95ad7	276	0.2%
Other values (32053)	111056	96.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	531	0.5%
99a4788cb24856965c36a24e339b6058	516	0.4%
422879e10f46682990de24d770e7f83d	506	0.4%
389d119b48cf3043d311335e499d9c6b	404	0.4%
368c6c730842d78016ad823897a372db	392	0.3%
53759a2ecddad2bb87a079a1f1519f73	389	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	353	0.3%
53b36df67ebb7c41585e8d54d6772e08	323	0.3%
154e7e31ebfa092203795c972e5804a6	291	0.3%
3dd2a17168ec895c781a9191c1e95ad7	276	0.2%
Other values (32053)	111056	96.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

seller_id
Categorical

HIGH CARDINALITY

Distinct	3021
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

4a3ca9315b744ce9f8e9374361493884	2126
6560211a19b47992c3666cc44a7e94c0	2105
1f50f920176fa81dab994f9023523100	2004
cc419e0650a3c5ba77189a1882b7556a	1871
da8622b14eb17ae2831f4ac5b9dab84a	1654
Other values (3016)	105277

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	488 ?
Unique (%)	0.4%

Sample

1st row	3504c0cb71d7fa48d967e0e4c94d59d9
2nd row	3504c0cb71d7fa48d967e0e4c94d59d9
3rd row	3504c0cb71d7fa48d967e0e4c94d59d9
4th row	3504c0cb71d7fa48d967e0e4c94d59d9
5th row	3504c0cb71d7fa48d967e0e4c94d59d9

Common Values

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2126	1.8%
6560211a19b47992c3666cc44a7e94c0	2105	1.8%
1f50f920176fa81dab994f9023523100	2004	1.7%
cc419e0650a3c5ba77189a1882b7556a	1871	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1654	1.4%
955fee9216a65b617aa5c0531780ce60	1513	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1460	1.3%
7c67e1448b00f6e969d365cea6b010ab	1451	1.3%
7a67c85e85bb2ce8582c35f2203ad736	1233	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1229	1.1%
Other values (3011)	98391	85.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2126	1.8%
6560211a19b47992c3666cc44a7e94c0	2105	1.8%
1f50f920176fa81dab994f9023523100	2004	1.7%
cc419e0650a3c5ba77189a1882b7556a	1871	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1654	1.4%
955fee9216a65b617aa5c0531780ce60	1513	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1460	1.3%
7c67e1448b00f6e969d365cea6b010ab	1451	1.3%
7a67c85e85bb2ce8582c35f2203ad736	1233	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1229	1.1%
Other values (3011)	98391	85.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

shipping_limit_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	90958
Distinct (%)	79.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

2017-08-14 20:43:31	63
2017-10-05 17:44:41	38
2017-04-27 09:10:13	29
2017-06-15 16:15:08	26
2018-05-15 15:30:28	24
Other values (90953)	114857

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	75119 ?
Unique (%)	65.3%

Sample

1st row	2017-10-06 11:07:15
2nd row	2017-10-06 11:07:15
3rd row	2017-10-06 11:07:15
4th row	2017-08-21 20:05:16
5th row	2017-08-08 18:37:31

Common Values

Value	Count	Frequency (%)
2017-08-14 20:43:31	63	0.1%
2017-10-05 17:44:41	38	< 0.1%
2017-04-27 09:10:13	29	< 0.1%
2017-06-15 16:15:08	26	< 0.1%
2018-05-15 15:30:28	24	< 0.1%
2018-02-27 12:28:15	24	< 0.1%
2017-07-13 15:10:17	24	< 0.1%
2017-03-15 23:39:26	24	< 0.1%
2017-11-30 14:16:34	24	< 0.1%
2017-10-24 13:06:21	22	< 0.1%
Other values (90948)	114739	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-11-30	1707	0.7%
2017-12-07	773	0.3%
2018-04-19	708	0.3%
2018-08-07	671	0.3%
2018-01-18	665	0.3%
2018-05-10	664	0.3%
2018-03-08	664	0.3%
2018-03-22	655	0.3%
2018-03-01	651	0.3%
2018-02-22	644	0.3%
Other values (40089)	222272	96.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5860
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.6500148

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	134.9
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	182.8531136
Coefficient of variation (CV)	1.515566442
Kurtosis	107.9174333
Mean	120.6500148
Median Absolute Deviation (MAD)	42
Skewness	7.618326263
Sum	13879215.75
Variance	33435.26114
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2561	2.2%
69.9	2089	1.8%
49.9	2005	1.7%
89.9	1598	1.4%
99.9	1491	1.3%
29.9	1355	1.2%
39.9	1321	1.1%
79.9	1263	1.1%
19.9	1253	1.1%
29.99	1202	1.0%
Other values (5850)	98899	86.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%
2.99	1	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	7	< 0.1%
3.54	1	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%
3999	2	< 0.1%

freight_value
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6944
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.04932535

Minimum	0
Maximum	409.68
Zeros	386
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.32
Q3	21.2
95-th percentile	45.332
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.12

Descriptive statistics

Standard deviation	15.85042324
Coefficient of variation (CV)	0.7905714015
Kurtosis	58.28785167
Mean	20.04932535
Median Absolute Deviation (MAD)	3.63
Skewness	5.563999669
Sum	2306414.24
Variance	251.2359169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3732	3.2%
7.78	2281	2.0%
11.85	1948	1.7%
14.1	1916	1.7%
18.23	1592	1.4%
7.39	1554	1.4%
16.11	1181	1.0%
15.23	1033	0.9%
8.72	948	0.8%
16.79	901	0.8%
Other values (6934)	97951	85.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	386	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	4	< 0.1%
0.05	3	< 0.1%
0.06	13	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

seller_zip_code_prefix
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2203
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24523.88605

Minimum	1001
Maximum	99730
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	1001
5-th percentile	2972
Q1	6429
median	13720
Q3	28470
95-th percentile	88330
Maximum	99730
Range	98729
Interquartile range (IQR)	22041

Descriptive statistics

Standard deviation	27644.64337
Coefficient of variation (CV)	1.127253785
Kurtosis	0.9073104887
Mean	24523.88605
Median Absolute Deviation (MAD)	8120
Skewness	1.548919582
Sum	2821154280
Variance	764226306.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14940	8200	7.1%
5849	2119	1.8%
15025	2085	1.8%
9015	1877	1.6%
13405	1665	1.4%
8577	1542	1.3%
4782	1532	1.3%
3204	1460	1.3%
4160	1257	1.1%
13232	1241	1.1%
Other values (2193)	92059	80.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1001	22	< 0.1%
1021	40	< 0.1%
1022	5	< 0.1%
1023	5	< 0.1%
1026	301	0.3%
1031	122	0.1%
1035	17	< 0.1%
1039	1	< 0.1%
1040	21	< 0.1%
1041	2	< 0.1%

Value	Count	Frequency (%)
99730	12	< 0.1%
99700	2	< 0.1%
99670	1	< 0.1%
99500	61	0.1%
99300	2	< 0.1%
98975	19	< 0.1%
98920	1	< 0.1%
98910	13	< 0.1%
98803	65	0.1%
98780	4	< 0.1%

seller_city
Categorical

HIGH CARDINALITY

Distinct	604
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

sao paulo	28595
ibitinga	8200
santo andre	3117
curitiba	3101
sao jose do rio preto	2662
Other values (599)	69362

Length

Max length	40
Median length	9
Mean length	10.10215844
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	68 ?
Unique (%)	0.1%

Sample

1st row	maua
2nd row	maua
3rd row	maua
4th row	maua
5th row	maua

Common Values

Value	Count	Frequency (%)
sao paulo	28595	24.9%
ibitinga	8200	7.1%
santo andre	3117	2.7%
curitiba	3101	2.7%
sao jose do rio preto	2662	2.3%
belo horizonte	2578	2.2%
rio de janeiro	2446	2.1%
ribeirao preto	2325	2.0%
maringa	2274	2.0%
guarulhos	2049	1.8%
Other values (594)	57690	50.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	35553	18.0%
paulo	28876	14.6%
ibitinga	8200	4.1%
rio	5791	2.9%
preto	5415	2.7%
do	5409	2.7%
jose	4026	2.0%
de	3908	2.0%
santo	3235	1.6%
andre	3132	1.6%
Other values (634)	94193	47.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

seller_state
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

SP	82041
PR	8943
MG	8922
RJ	4891
SC	4217
Other values (18)	6023

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	82041	71.3%
PR	8943	7.8%
MG	8922	7.8%
RJ	4891	4.3%
SC	4217	3.7%
RS	2216	1.9%
DF	893	0.8%
BA	693	0.6%
GO	535	0.5%
PE	460	0.4%
Other values (13)	1226	1.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	82041	71.3%
pr	8943	7.8%
mg	8922	7.8%
rj	4891	4.3%
sc	4217	3.7%
rs	2216	1.9%
df	893	0.8%
ba	693	0.6%
go	535	0.5%
pe	460	0.4%
Other values (13)	1226	1.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_unique_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	92939
Distinct (%)	80.8%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

9a736b248f67d166d2fbb006bcb877c3	75
6fbc7cdadbb522125f4b27ae9dee4060	38
f9ae226291893fda10af7965268fb7f6	35
8af7ac63b2efbcbd88e5b11505e8098a	29
569aa12b73b5f7edeaa6f2a01603e381	26
Other values (92934)	114834

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	78991 ?
Unique (%)	68.7%

Sample

1st row	7c396fd4830fd04220f754e42b4e5bff
2nd row	7c396fd4830fd04220f754e42b4e5bff
3rd row	7c396fd4830fd04220f754e42b4e5bff
4th row	3a51803cc0d012c3b5dc8b7528cb05f7
5th row	ef0996a1a279c26e7ecbd737be23d235

Common Values

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
8af7ac63b2efbcbd88e5b11505e8098a	29	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b	24	< 0.1%
90807fdb59eec2152bc977feeb6e47e7	24	< 0.1%
1d2435aa3b858d45c707c9fc25e18779	24	< 0.1%
Other values (92929)	114714	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
8af7ac63b2efbcbd88e5b11505e8098a	29	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
85963fd37bfd387aa6d915d8a1065486	24	< 0.1%
c8460e4251689ba205045f3ea17884a1	24	< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b	24	< 0.1%
90807fdb59eec2152bc977feeb6e47e7	24	< 0.1%
1d2435aa3b858d45c707c9fc25e18779	24	< 0.1%
Other values (92929)	114714	99.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_zip_code_prefix
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	14747
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34983.3783

Minimum	1003
Maximum	99980
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	1003
5-th percentile	3280
Q1	11095
median	24230
Q3	58297
95-th percentile	90620
Maximum	99980
Range	98977
Interquartile range (IQR)	47202

Descriptive statistics

Standard deviation	29829.43897
Coefficient of variation (CV)	0.852674625
Kurtosis	-0.7723390905
Mean	34983.3783
Median Absolute Deviation (MAD)	16199
Skewness	0.7907870136
Sum	4024382889
Variance	889795429.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24220	154	0.1%
22793	151	0.1%
22790	149	0.1%
24230	138	0.1%
22775	126	0.1%
35162	123	0.1%
29101	112	0.1%
13087	107	0.1%
11740	106	0.1%
36570	104	0.1%
Other values (14737)	113767	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%
1008	3	< 0.1%
1009	8	< 0.1%
1011	6	< 0.1%
1012	2	< 0.1%
1013	3	< 0.1%

Value	Count	Frequency (%)
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	1	< 0.1%
99955	3	< 0.1%
99950	9	< 0.1%
99940	2	< 0.1%
99930	5	< 0.1%
99925	1	< 0.1%
99920	1	< 0.1%

customer_city
Categorical

HIGH CARDINALITY

Distinct	4044
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

sao paulo	18224
rio de janeiro	7993
belo horizonte	3186
brasilia	2236
curitiba	1786
Other values (4039)	81612

Length

Max length	32
Median length	9
Mean length	10.33729148
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1004 ?
Unique (%)	0.9%

Sample

1st row	sao paulo
2nd row	sao paulo
3rd row	sao paulo
4th row	sao paulo
5th row	sao paulo

Common Values

Value	Count	Frequency (%)
sao paulo	18224	15.8%
rio de janeiro	7993	6.9%
belo horizonte	3186	2.8%
brasilia	2236	1.9%
curitiba	1786	1.6%
campinas	1698	1.5%
porto alegre	1625	1.4%
salvador	1459	1.3%
guarulhos	1368	1.2%
sao bernardo do campo	1094	1.0%
Other values (4034)	74368	64.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sao	24557	12.2%
paulo	18305	9.1%
de	11227	5.6%
rio	9596	4.8%
janeiro	7993	4.0%
do	4944	2.4%
belo	3259	1.6%
horizonte	3214	1.6%
brasilia	2246	1.1%
porto	1934	1.0%
Other values (3234)	114544	56.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

customer_state
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

SP	48683
RJ	14929
MG	13386
RS	6392
PR	5854
Other values (22)	25793

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	48683	42.3%
RJ	14929	13.0%
MG	13386	11.6%
RS	6392	5.6%
PR	5854	5.1%
SC	4209	3.7%
BA	3920	3.4%
GO	2346	2.0%
ES	2285	2.0%
DF	2251	2.0%
Other values (17)	10782	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	48683	42.3%
rj	14929	13.0%
mg	13386	11.6%
rs	6392	5.6%
pr	5854	5.1%
sc	4209	3.7%
ba	3920	3.4%
go	2346	2.0%
es	2285	2.0%
df	2251	2.0%
Other values (17)	10782	9.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

product_category_name
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	71
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

cama_mesa_banho	11819
beleza_saude	9914
esporte_lazer	8925
moveis_decoracao	8723
informatica_acessorios	8075
Other values (66)	67581

Length

Max length	46
Median length	15
Mean length	14.88322887
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	utilidades_domesticas
2nd row	utilidades_domesticas
3rd row	utilidades_domesticas
4th row	utilidades_domesticas
5th row	utilidades_domesticas

Common Values

Value	Count	Frequency (%)
cama_mesa_banho	11819	10.3%
beleza_saude	9914	8.6%
esporte_lazer	8925	7.8%
moveis_decoracao	8723	7.6%
informatica_acessorios	8075	7.0%
utilidades_domesticas	7312	6.4%
relogios_presentes	6136	5.3%
telefonia	4661	4.1%
ferramentas_jardim	4547	4.0%
automotivo	4346	3.8%
Other values (61)	40579	35.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cama_mesa_banho	11819	10.3%
beleza_saude	9914	8.6%
esporte_lazer	8925	7.8%
moveis_decoracao	8723	7.6%
informatica_acessorios	8075	7.0%
utilidades_domesticas	7312	6.4%
relogios_presentes	6136	5.3%
telefonia	4661	4.1%
ferramentas_jardim	4547	4.0%
automotivo	4346	3.8%
Other values (61)	40579	35.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

product_name_lenght
Real number (ℝ_≥0)

Distinct	66
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.75428775

Minimum	5
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	5
5-th percentile	29
Q1	42
median	52
Q3	57
95-th percentile	60
Maximum	76
Range	71
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.03833567
Coefficient of variation (CV)	0.2058964684
Kurtosis	0.1464021057
Mean	48.75428775
Median Absolute Deviation (MAD)	6
Skewness	-0.9041148344
Sum	5608547
Variance	100.768183
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	8570	7.4%
60	7904	6.9%
56	6775	5.9%
58	6712	5.8%
57	6219	5.4%
55	5773	5.0%
54	5443	4.7%
53	4306	3.7%
52	4242	3.7%
49	3659	3.2%
Other values (56)	55434	48.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	4	< 0.1%
9	14	< 0.1%
10	8	< 0.1%
11	11	< 0.1%
12	37	< 0.1%
13	26	< 0.1%
14	46	< 0.1%

Value	Count	Frequency (%)
76	1	< 0.1%
72	9	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	3	< 0.1%
66	1	< 0.1%
64	169	0.1%
63	1332	1.2%
62	160	0.1%
61	238	0.2%

product_description_lenght
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2958
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	785.867573

Minimum	4
Maximum	3992
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	4
5-th percentile	159.8
Q1	345
median	600
Q3	982
95-th percentile	2125.2
Maximum	3992
Range	3988
Interquartile range (IQR)	637

Descriptive statistics

Standard deviation	653.0514924
Coefficient of variation (CV)	0.8309943238
Kurtosis	4.91709565
Mean	785.867573
Median Absolute Deviation (MAD)	296
Skewness	2.011066015
Sum	90403848
Variance	426476.2518
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
341	706	0.6%
1893	663	0.6%
348	642	0.6%
492	588	0.5%
903	586	0.5%
245	575	0.5%
366	529	0.5%
236	510	0.4%
340	483	0.4%
919	436	0.4%
Other values (2948)	109319	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	6	< 0.1%
8	2	< 0.1%
15	1	< 0.1%
20	7	< 0.1%
23	1	< 0.1%
26	2	< 0.1%
27	4	< 0.1%
28	2	< 0.1%
30	8	< 0.1%
31	2	< 0.1%

Value	Count	Frequency (%)
3992	2	< 0.1%
3988	1	< 0.1%
3985	3	< 0.1%
3976	6	< 0.1%
3963	1	< 0.1%
3956	3	< 0.1%
3954	2	< 0.1%
3950	2	< 0.1%
3949	1	< 0.1%
3948	1	< 0.1%

product_photos_qty
Real number (ℝ_≥0)

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.200318159

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.713212606
Coefficient of variation (CV)	0.7786204006
Kurtosis	4.907432821
Mean	2.200318159
Median Absolute Deviation (MAD)	0
Skewness	1.919275288
Sum	253118
Variance	2.935097433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	58264	50.6%
2	22763	19.8%
3	12791	11.1%
4	8720	7.6%
5	5540	4.8%
6	3872	3.4%
7	1463	1.3%
8	766	0.7%
10	351	0.3%
9	309	0.3%
Other values (9)	198	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	58264	50.6%
2	22763	19.8%
3	12791	11.1%
4	8720	7.6%
5	5540	4.8%
6	3872	3.4%
7	1463	1.3%
8	766	0.7%
9	309	0.3%
10	351	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	12	< 0.1%
14	6	< 0.1%
13	30	< 0.1%
12	60	0.1%
11	72	0.1%
10	351	0.3%

product_weight_g
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2197
Distinct (%)	1.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2112.365746

Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9850
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3776.693083
Coefficient of variation (CV)	1.787897332
Kurtosis	15.932725
Mean	2112.365746
Median Absolute Deviation (MAD)	500
Skewness	3.570368112
Sum	242998106
Variance	14263410.64
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	6788	5.9%
150	5295	4.6%
250	4657	4.0%
300	4295	3.7%
100	3559	3.1%
400	3460	3.0%
350	3204	2.8%
500	2775	2.4%
600	2763	2.4%
700	2083	1.8%
Other values (2187)	76157	66.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	982	0.9%
53	2	< 0.1%
54	2	< 0.1%
55	2	< 0.1%
58	1	< 0.1%
60	9	< 0.1%
61	5	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	285	0.2%
29800	1	< 0.1%
29750	1	< 0.1%
29700	4	< 0.1%
29600	5	< 0.1%
29500	2	< 0.1%
29250	1	< 0.1%
29150	1	< 0.1%
29100	1	< 0.1%

product_length_cm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	99
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	30.30089711

Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.20368427
Coefficient of variation (CV)	0.5347592256
Kurtosis	3.668261707
Mean	30.30089711
Median Absolute Deviation (MAD)	8
Skewness	1.74206068
Sum	3485694
Variance	262.5593841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	17652	15.3%
20	10556	9.2%
30	7746	6.7%
17	6103	5.3%
18	5826	5.1%
19	4832	4.2%
25	4750	4.1%
40	4230	3.7%
22	3911	3.4%
50	3081	2.7%
Other values (89)	46349	40.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%
12	40	< 0.1%
13	60	0.1%
14	136	0.1%
15	212	0.2%
16	17652	15.3%

Value	Count	Frequency (%)
105	329	0.3%
104	30	< 0.1%
103	45	< 0.1%
102	60	0.1%
101	107	0.1%
100	423	0.4%
99	36	< 0.1%
98	49	< 0.1%
97	11	< 0.1%
96	8	< 0.1%

product_height_cm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	102
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	16.65871553

Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.48410769
Coefficient of variation (CV)	0.809432616
Kurtosis	7.274135572
Mean	16.65871553
Median Absolute Deviation (MAD)	6
Skewness	2.240967679
Sum	1916352
Variance	181.8211603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10097	8.8%
20	6775	5.9%
15	6763	5.9%
11	6250	5.4%
12	6172	5.4%
2	5039	4.4%
4	4757	4.1%
8	4747	4.1%
16	4650	4.0%
5	4613	4.0%
Other values (92)	55173	48.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	5039	4.4%
3	2761	2.4%
4	4757	4.1%
5	4613	4.0%
6	3490	3.0%
7	4185	3.6%
8	4747	4.1%
9	3360	2.9%
10	10097	8.8%
11	6250	5.4%

Value	Count	Frequency (%)
105	137	0.1%
104	14	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	42	< 0.1%
99	5	< 0.1%
98	3	< 0.1%
97	2	< 0.1%
96	8	< 0.1%
95	22	< 0.1%

product_width_cm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	95
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	23.10408915

Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.73032474
Coefficient of variation (CV)	0.5077163898
Kurtosis	4.532601408
Mean	23.10408915
Median Absolute Deviation (MAD)	6
Skewness	1.699763004
Sum	2657802
Variance	137.6005184
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12401	10.8%
11	10622	9.2%
15	8935	7.8%
16	8653	7.5%
30	7819	6.8%
12	5568	4.8%
13	5384	4.7%
14	4723	4.1%
18	4034	3.5%
40	4034	3.5%
Other values (85)	42863	37.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	51	< 0.1%
10	83	0.1%
11	10622	9.2%
12	5568	4.8%
13	5384	4.7%
14	4723	4.1%
15	8935	7.8%

Value	Count	Frequency (%)
118	7	< 0.1%
105	14	< 0.1%
104	1	< 0.1%
103	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%
100	43	< 0.1%
98	1	< 0.1%
97	1	< 0.1%
95	2	< 0.1%

payment_sequential
Real number (ℝ_≥0)

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.094056695

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	29
Range	28
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7315441733
Coefficient of variation (CV)	0.6686528923
Kurtosis	348.8888491
Mean	1.094056695
Median Absolute Deviation (MAD)	0
Skewness	15.96822497
Sum	125857
Variance	0.5351568775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	110108	95.7%
2	3280	2.9%
3	636	0.6%
4	307	0.3%
5	183	0.2%
6	127	0.1%
7	88	0.1%
8	58	0.1%
9	47	< 0.1%
10	40	< 0.1%
Other values (19)	163	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	110108	95.7%
2	3280	2.9%
3	636	0.6%
4	307	0.3%
5	183	0.2%
6	127	0.1%
7	88	0.1%
8	58	0.1%
9	47	< 0.1%
10	40	< 0.1%

Value	Count	Frequency (%)
29	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	2	< 0.1%
25	2	< 0.1%
24	2	< 0.1%
23	2	< 0.1%
22	3	< 0.1%
21	6	< 0.1%
20	6	< 0.1%

payment_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

credit_card	84834
boleto	22406
voucher	6142
debit_card	1655

Length

Max length	11
Median length	11
Mean length	9.79818667
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	voucher
3rd row	voucher
4th row	credit_card
5th row	credit_card

Common Values

Value	Count	Frequency (%)
credit_card	84834	73.7%
boleto	22406	19.5%
voucher	6142	5.3%
debit_card	1655	1.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
credit_card	84834	73.7%
boleto	22406	19.5%
voucher	6142	5.3%
debit_card	1655	1.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

payment_installments
Real number (ℝ_≥0)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.944565661

Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.780108304
Coefficient of variation (CV)	0.9441488572
Kurtosis	2.529947266
Mean	2.944565661
Median Absolute Deviation (MAD)	1
Skewness	1.620915505
Sum	338734
Variance	7.729002184
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	57328	49.8%
2	13352	11.6%
3	11498	10.0%
4	7820	6.8%
10	6740	5.9%
5	5888	5.1%
8	4978	4.3%
6	4519	3.9%
7	1779	1.5%
9	708	0.6%
Other values (14)	427	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	57328	49.8%
2	13352	11.6%
3	11498	10.0%
4	7820	6.8%
5	5888	5.1%
6	4519	3.9%
7	1779	1.5%
8	4978	4.3%
9	708	0.6%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	6	< 0.1%
20	20	< 0.1%
18	38	< 0.1%
17	7	< 0.1%
16	7	< 0.1%
15	91	0.1%
14	16	< 0.1%

payment_value
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	28598
Distinct (%)	24.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	172.4092939

Minimum	0
Maximum	13664.08
Zeros	6
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	0
5-th percentile	27.19
Q1	60.85
median	108
Q3	189.43
95-th percentile	515.1
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.58

Descriptive statistics

Standard deviation	266.2045083
Coefficient of variation (CV)	1.54402644
Kurtosis	524.9065678
Mean	172.4092939
Median Absolute Deviation (MAD)	56.75
Skewness	14.31714272
Sum	19833447.94
Variance	70864.84021
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	337	0.3%
20	283	0.2%
100	282	0.2%
77.57	247	0.2%
35	162	0.1%
73.34	157	0.1%
30	133	0.1%
116.94	130	0.1%
56.78	120	0.1%
155.14	119	0.1%
Other values (28588)	113067	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	2	< 0.1%
0.13	1	< 0.1%
0.14	4	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6726.66	1	< 0.1%
6081.54	6	< 0.1%
4950.34	1	< 0.1%
4809.44	2	< 0.1%
4764.34	1	< 0.1%
4681.78	1	< 0.1%
4513.32	1	< 0.1%

product_category_name_english
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	71
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

bed_bath_table	11819
health_beauty	9914
sports_leisure	8925
furniture_decor	8723
computers_accessories	8075
Other values (66)	67581

Length

Max length	39
Median length	13
Mean length	12.99040309
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	housewares
2nd row	housewares
3rd row	housewares
4th row	housewares
5th row	housewares

Common Values

Value	Count	Frequency (%)
bed_bath_table	11819	10.3%
health_beauty	9914	8.6%
sports_leisure	8925	7.8%
furniture_decor	8723	7.6%
computers_accessories	8075	7.0%
housewares	7312	6.4%
watches_gifts	6136	5.3%
telephony	4661	4.1%
garden_tools	4547	4.0%
auto	4346	3.8%
Other values (61)	40579	35.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bed_bath_table	11819	10.3%
health_beauty	9914	8.6%
sports_leisure	8925	7.8%
furniture_decor	8723	7.6%
computers_accessories	8075	7.0%
housewares	7312	6.4%
watches_gifts	6136	5.3%
telephony	4661	4.1%
garden_tools	4547	4.0%
auto	4346	3.8%
Other values (61)	40579	35.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

geolocation_lat_customer
Real number (ℝ)

HIGH CORRELATION

Distinct	14743
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-21.23576548

Minimum	-36.60537441
Maximum	42.18400274
Zeros	0
Zeros (%)	0.0%
Negative	114914
Negative (%)	99.9%
Memory size	898.9 KiB

Quantile statistics

Minimum	-36.60537441
5-th percentile	-28.62869711
Q1	-23.59002278
median	-22.92991227
Q3	-20.19822232
95-th percentile	-7.97347196
Maximum	42.18400274
Range	78.78937715
Interquartile range (IQR)	3.391800461

Descriptive statistics

Standard deviation	5.571870904
Coefficient of variation (CV)	-0.2623814483
Kurtosis	3.501648759
Mean	-21.23576548
Median Absolute Deviation (MAD)	0.8913251649
Skewness	1.663469957
Sum	-2442898.754
Variance	31.04574537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22.90581655	154	0.1%
-23.00927096	151	0.1%
-23.01133469	149	0.1%
-22.91127038	138	0.1%
-22.97295652	126	0.1%
-19.47809554	123	0.1%
-20.33161264	112	0.1%
-22.85275771	107	0.1%
-24.14965101	106	0.1%
-20.72193768	104	0.1%
Other values (14733)	113767	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-36.60537441	12	< 0.1%
-34.58642211	1	< 0.1%
-33.69142292	5	< 0.1%
-33.52560057	15	< 0.1%
-32.5639516	9	< 0.1%
-32.23127878	4	< 0.1%
-32.20521717	1	< 0.1%
-32.20428523	3	< 0.1%
-32.18884625	4	< 0.1%
-32.18810995	2	< 0.1%

Value	Count	Frequency (%)
42.18400274	1	< 0.1%
41.14620291	2	< 0.1%
39.05762942	2	< 0.1%
3.844901491	1	< 0.1%
3.358232038	1	< 0.1%
2.859929195	4	< 0.1%
2.84462475	1	< 0.1%
2.833882311	3	< 0.1%
2.830159586	5	< 0.1%
2.824144071	1	< 0.1%

geolocation_lng_customer
Real number (ℝ)

HIGH CORRELATION

Distinct	14744
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-46.19785734

Minimum	-72.66670555
Maximum	-8.577855018
Zeros	0
Zeros (%)	0.0%
Negative	115037
Negative (%)	100.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	-72.66670555
5-th percentile	-52.38356841
Q1	-48.101695
median	-46.632021
Q3	-43.62599281
95-th percentile	-38.5059849
Maximum	-8.577855018
Range	64.08885053
Interquartile range (IQR)	4.475702196

Descriptive statistics

Standard deviation	4.05064469
Coefficient of variation (CV)	-0.08768035843
Kurtosis	2.271704084
Mean	-46.19785734
Median Absolute Deviation (MAD)	2.439993631
Skewness	0.02812258526
Sum	-5314462.915
Variance	16.40772241
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-43.10698886	154	0.1%
-43.42940928	151	0.1%
-43.45025642	149	0.1%
-43.10515134	138	0.1%
-43.39706328	126	0.1%
-42.55679483	123	0.1%
-40.27958609	112	0.1%
-47.05510214	107	0.1%
-46.7480979	106	0.1%
-42.8660116	104	0.1%
Other values (14734)	113767	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-72.66670555	3	< 0.1%
-69.2590519	1	< 0.1%
-68.7420032	3	< 0.1%
-68.7409412	1	< 0.1%
-68.50800699	2	< 0.1%
-67.88426965	1	< 0.1%
-67.85151077	8	< 0.1%
-67.84345651	6	< 0.1%
-67.83786946	9	< 0.1%
-67.83511725	13	< 0.1%

Value	Count	Frequency (%)
-8.577855018	2	< 0.1%
-8.723762148	1	< 0.1%
-9.400036925	2	< 0.1%
-34.80034036	1	< 0.1%
-34.80818636	1	< 0.1%
-34.82458363	7	< 0.1%
-34.82467295	14	< 0.1%
-34.82528062	6	< 0.1%
-34.82560511	2	< 0.1%
-34.82644069	7	< 0.1%

geolocation_lat_seller
Real number (ℝ)

HIGH CORRELATION

Distinct	2203
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-22.79605947

Minimum	-36.60537441
Maximum	-2.546079234
Zeros	0
Zeros (%)	0.0%
Negative	115037
Negative (%)	100.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	-36.60537441
5-th percentile	-26.33054814
Q1	-23.61165419
median	-23.42073909
Q3	-21.76647685
95-th percentile	-19.8498827
Maximum	-2.546079234
Range	34.05929518
Interquartile range (IQR)	1.845177347

Descriptive statistics

Standard deviation	2.696611906
Coefficient of variation (CV)	-0.1182928966
Kurtosis	18.18706634
Mean	-22.79605947
Median Absolute Deviation (MAD)	0.5381883235
Skewness	2.764194626
Sum	-2622390.294
Variance	7.271715773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-21.76647685	8200	7.1%
-23.65111484	2119	1.8%
-20.80243626	2085	1.8%
-23.66570346	1877	1.6%
-22.71683929	1665	1.4%
-23.48262344	1542	1.3%
-23.693986	1532	1.3%
-23.59798552	1460	1.3%
-23.62358155	1257	1.1%
-23.20706431	1241	1.1%
Other values (2193)	92059	80.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-36.60537441	4	< 0.1%
-32.07951338	18	< 0.1%
-31.77241287	2	< 0.1%
-31.32151917	1	< 0.1%
-30.1594693	76	0.1%
-30.1100209	19	< 0.1%
-30.10330372	6	< 0.1%
-30.09981943	5	< 0.1%
-30.08061351	5	< 0.1%
-30.07200824	48	< 0.1%

Value	Count	Frequency (%)
-2.546079234	401	0.3%
-3.135622683	3	< 0.1%
-3.719036598	14	< 0.1%
-3.723306129	3	< 0.1%
-3.723672447	1	< 0.1%
-3.743987899	4	< 0.1%
-3.759209507	1	< 0.1%
-3.769923	34	< 0.1%
-3.780360995	12	< 0.1%
-3.783814827	16	< 0.1%

geolocation_lng_seller
Real number (ℝ)

HIGH CORRELATION

Distinct	2203
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-47.24790942

Minimum	-67.8096558
Maximum	-34.84785618
Zeros	0
Zeros (%)	0.0%
Negative	115037
Negative (%)	100.0%
Memory size	898.9 KiB

Quantile statistics

Minimum	-67.8096558
5-th percentile	-51.39151634
Q1	-48.83154738
median	-46.75521082
Q3	-46.51808197
95-th percentile	-43.30459253
Maximum	-34.84785618
Range	32.96179962
Interquartile range (IQR)	2.313465411

Descriptive statistics

Standard deviation	2.346335751
Coefficient of variation (CV)	-0.0496600967
Kurtosis	4.851139313
Mean	-47.24790942
Median Absolute Deviation (MAD)	0.7668289084
Skewness	0.5590092336
Sum	-5435257.755
Variance	5.505291455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-48.83154738	8200	7.1%
-46.75521082	2119	1.8%
-49.39562407	2085	1.8%
-46.51808197	1877	1.6%
-47.65736585	1665	1.4%
-46.37448953	1542	1.3%
-46.70188324	1532	1.3%
-46.55547279	1460	1.3%
-46.61056007	1257	1.1%
-46.76073521	1241	1.1%
Other values (2193)	92059	80.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-67.8096558	1	< 0.1%
-64.28394646	4	< 0.1%
-63.88797299	6	< 0.1%
-61.95720116	8	< 0.1%
-60.02346888	3	< 0.1%
-57.08632042	1	< 0.1%
-56.10296014	52	< 0.1%
-56.06797233	37	< 0.1%
-55.49644289	56	< 0.1%
-54.96989318	2	< 0.1%

Value	Count	Frequency (%)
-34.84785618	1	< 0.1%
-34.8557625	6	< 0.1%
-34.89678629	3	< 0.1%
-34.89853108	14	< 0.1%
-34.90155285	1	< 0.1%
-34.91839939	6	< 0.1%
-34.93222646	384	0.3%
-35.12509238	15	< 0.1%
-35.20164321	23	< 0.1%
-35.20826027	16	< 0.1%

review_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	95840
Distinct (%)	83.3%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

eef5dbca8d37dfce6db7d7b16dd0525e	63
7145a6f0d38ec713897856cbdcfcdb7f	38
f28281373ab8815bafafe371218f02ce	29
8823bba1e3301fee652eb06de8ef9435	26
b5292206f96cd5d97359940203a0b510	24
Other values (95835)	114857

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83179 ?
Unique (%)	72.3%

Sample

1st row	a54f0611adc9ed256b57ede6b6eb5114
2nd row	a54f0611adc9ed256b57ede6b6eb5114
3rd row	a54f0611adc9ed256b57ede6b6eb5114
4th row	b46f1e34512b0f4c74a72398b03ca788
5th row	dc90f19c2806f1abba9e72ad3c350073

Common Values

Value	Count	Frequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e	63	0.1%
7145a6f0d38ec713897856cbdcfcdb7f	38	< 0.1%
f28281373ab8815bafafe371218f02ce	29	< 0.1%
8823bba1e3301fee652eb06de8ef9435	26	< 0.1%
b5292206f96cd5d97359940203a0b510	24	< 0.1%
cc074f1c33940c4f0dd904705f98e39e	24	< 0.1%
b0c2f8c122ebef9f77753f7d167cf634	24	< 0.1%
b79b22bb50f78f1afe361661011fd892	24	< 0.1%
7e568736c98c553aea896a5dca746d5a	22	< 0.1%
6fe49ee0a2b00dddf7ebddb5847f9283	21	< 0.1%
Other values (95830)	114742	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e	63	0.1%
7145a6f0d38ec713897856cbdcfcdb7f	38	< 0.1%
f28281373ab8815bafafe371218f02ce	29	< 0.1%
8823bba1e3301fee652eb06de8ef9435	26	< 0.1%
b5292206f96cd5d97359940203a0b510	24	< 0.1%
cc074f1c33940c4f0dd904705f98e39e	24	< 0.1%
b0c2f8c122ebef9f77753f7d167cf634	24	< 0.1%
b79b22bb50f78f1afe361661011fd892	24	< 0.1%
7e568736c98c553aea896a5dca746d5a	22	< 0.1%
e8236fe7b6e1bdd513a500de361e2b87	21	< 0.1%
Other values (95830)	114742	99.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

review_score
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

5	65048
4	21844
1	14475
3	9665
2	4005

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	5

Common Values

Value	Count	Frequency (%)
5	65048	56.5%
4	21844	19.0%
1	14475	12.6%
3	9665	8.4%
2	4005	3.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
5	65048	56.5%
4	21844	19.0%
1	14475	12.6%
3	9665	8.4%
2	4005	3.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

review_comment_title
Categorical

HIGH CARDINALITY
MISSING

Distinct	4455
Distinct (%)	32.4%
Missing	101302
Missing (%)	88.1%
Memory size	898.9 KiB

Recomendo	487
recomendo	400
Bom	327
super recomendo	309
Excelente	291
Other values (4450)	11921

Length

Max length	26
Median length	11
Mean length	12.18340007
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3049 ?
Unique (%)	22.2%

Sample

1st row	Cortina de qualidade
2nd row	Cumpriu com o pro
3rd row	pessimo atendimento
4th row	Muito bom os produtos
5th row	Muito bom os produtos

Common Values

Value	Count	Frequency (%)
Recomendo	487	0.4%
recomendo	400	0.3%
Bom	327	0.3%
super recomendo	309	0.3%
Excelente	291	0.3%
Muito bom	278	0.2%
Ótimo	267	0.2%
Super recomendo	252	0.2%
Ótimo	234	0.2%
Otimo	201	0.2%
Other values (4445)	10689	9.3%
(Missing)	101302	88.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
recomendo	2431	9.3%
produto	1534	5.9%
bom	1502	5.7%
muito	1033	3.9%
super	1028	3.9%
não	901	3.4%
ótimo	797	3.0%
excelente	761	2.9%
entrega	691	2.6%
recebi	429	1.6%
Other values (2070)	15100	57.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

review_comment_message
Categorical

HIGH CARDINALITY
MISSING

Distinct	35020
Distinct (%)	71.9%
Missing	66357
Missing (%)	57.7%
Memory size	898.9 KiB

Muito bom	253
Bom	206
muito bom	133
bom	115
Otimo	114
Other values (35015)	47859

Length

Max length	208
Median length	54
Mean length	70.24172145
Min length	1

Characters and Unicode

Total characters	6736
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28603 ?
Unique (%)	58.8%

Sample

1st row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
2nd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
3rd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
4th row	Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.
5th row	Só achei ela pequena pra seis xícaras ,mais é um bom produto

Common Values

Value	Count	Frequency (%)
Muito bom	253	0.2%
Bom	206	0.2%
muito bom	133	0.1%
bom	115	0.1%
Otimo	114	0.1%
Recomendo	109	0.1%
otimo	103	0.1%
Ok	86	0.1%
Ótimo	85	0.1%
Ótimo	82	0.1%
Other values (35010)	47394	41.2%
(Missing)	66357	57.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
o	21976	3.8%
produto	20397	3.5%
e	19319	3.3%
a	14683	2.5%
de	14025	2.4%
do	12741	2.2%
não	12650	2.2%
que	10090	1.7%
prazo	9213	1.6%
muito	8894	1.5%
Other values (19275)	439767	75.3%

Most occurring characters

Value	Count	Frequency (%)
	6736	100.0%

Most occurring categories

Value	Count	Frequency (%)
Control	6736	100.0%

Most frequent character per category

Control

Value	Count	Frequency (%)
	6736	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6736	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	6736	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6736	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	6736	100.0%

review_creation_date
Categorical

HIGH CARDINALITY

Distinct	632
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

2017-12-19 00:00:00	531
2018-05-22 00:00:00	515
2018-05-15 00:00:00	514
2017-12-20 00:00:00	502
2018-05-19 00:00:00	500
Other values (627)	112475

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25 ?
Unique (%)	< 0.1%

Sample

1st row	2017-10-11 00:00:00
2nd row	2017-10-11 00:00:00
3rd row	2017-10-11 00:00:00
4th row	2017-08-19 00:00:00
5th row	2017-08-08 00:00:00

Common Values

Value	Count	Frequency (%)
2017-12-19 00:00:00	531	0.5%
2018-05-22 00:00:00	515	0.4%
2018-05-15 00:00:00	514	0.4%
2017-12-20 00:00:00	502	0.4%
2018-05-19 00:00:00	500	0.4%
2018-08-28 00:00:00	497	0.4%
2018-05-04 00:00:00	495	0.4%
2018-03-29 00:00:00	490	0.4%
2018-03-30 00:00:00	477	0.4%
2018-08-14 00:00:00	476	0.4%
Other values (622)	110040	95.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	114942	50.0%
2017-12-19	531	0.2%
2018-05-22	515	0.2%
2018-05-15	514	0.2%
2017-12-20	502	0.2%
2018-05-19	500	0.2%
2018-08-28	497	0.2%
2018-05-04	495	0.2%
2018-03-29	490	0.2%
2018-03-30	477	0.2%
Other values (624)	110611	48.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

review_answer_timestamp
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	95685
Distinct (%)	83.2%
Missing	0
Missing (%)	0.0%
Memory size	898.9 KiB

2017-08-17 22:17:55	63
2017-10-19 21:08:44	38
2017-05-24 16:21:27	29
2017-06-28 18:49:50	26
2018-03-07 15:08:10	24
Other values (95680)	114857

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	82913 ?
Unique (%)	72.1%

Sample

1st row	2017-10-12 03:43:48
2nd row	2017-10-12 03:43:48
3rd row	2017-10-12 03:43:48
4th row	2017-08-20 15:16:36
5th row	2017-08-08 23:26:23

Common Values

Value	Count	Frequency (%)
2017-08-17 22:17:55	63	0.1%
2017-10-19 21:08:44	38	< 0.1%
2017-05-24 16:21:27	29	< 0.1%
2017-06-28 18:49:50	26	< 0.1%
2018-03-07 15:08:10	24	< 0.1%
2017-03-23 08:34:13	24	< 0.1%
2017-08-01 13:20:31	24	< 0.1%
2018-06-04 19:04:20	24	< 0.1%
2017-12-22 20:33:52	22	< 0.1%
2018-06-15 19:25:55	21	< 0.1%
Other values (95675)	114742	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2018-05-20	768	0.3%
2018-05-21	677	0.3%
2018-05-10	582	0.3%
2017-12-20	464	0.2%
2018-04-13	421	0.2%
2018-05-11	410	0.2%
2018-08-24	410	0.2%
2017-12-13	410	0.2%
2017-12-22	407	0.2%
2017-12-21	402	0.2%
Other values (53254)	225123	97.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	order_id	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	seller_zip_code_prefix	seller_city	seller_state	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	payment_sequential	payment_type	payment_installments	payment_value	product_category_name_english	geolocation_lat_customer	geolocation_lng_customer	geolocation_lat_seller	geolocation_lng_seller	review_id	review_score	review_comment_title	review_comment_message	review_creation_date	review_answer_timestamp
0	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	9350	maua	SP	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	1	credit_card	1	18.12	housewares	-23.574809	-46.587471	-23.680114	-46.452454	a54f0611adc9ed256b57ede6b6eb5114	4	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48
1	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	9350	maua	SP	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	3	voucher	1	2.00	housewares	-23.574809	-46.587471	-23.680114	-46.452454	a54f0611adc9ed256b57ede6b6eb5114	4	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48
2	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2017-10-02 10:56:33	2017-10-02 11:07:15	2017-10-04 19:55:00	2017-10-10 21:25:13	2017-10-18 00:00:00	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	9350	maua	SP	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	2	voucher	1	18.59	housewares	-23.574809	-46.587471	-23.680114	-46.452454	a54f0611adc9ed256b57ede6b6eb5114	4	NaN	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.	2017-10-11 00:00:00	2017-10-12 03:43:48
3	128e10d95713541c87cd1a2e48201934	a20e8105f23924cd00833fd87daa0831	delivered	2017-08-15 18:29:31	2017-08-15 20:05:16	2017-08-17 15:28:33	2017-08-18 14:44:43	2017-08-28 00:00:00	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-21 20:05:16	29.99	7.78	9350	maua	SP	3a51803cc0d012c3b5dc8b7528cb05f7	3366	sao paulo	SP	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	1	credit_card	3	37.77	housewares	-23.565578	-46.534603	-23.680114	-46.452454	b46f1e34512b0f4c74a72398b03ca788	4	NaN	Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.	2017-08-19 00:00:00	2017-08-20 15:16:36
4	0e7e841ddf8f8f2de2bad69267ecfbcf	26c7ac168e1433912a51b924fbd34d34	delivered	2017-08-02 18:24:47	2017-08-02 18:43:15	2017-08-04 17:35:43	2017-08-07 18:30:01	2017-08-15 00:00:00	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-08 18:37:31	29.99	7.78	9350	maua	SP	ef0996a1a279c26e7ecbd737be23d235	2290	sao paulo	SP	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	1	credit_card	1	37.77	housewares	-23.543295	-46.630743	-23.680114	-46.452454	dc90f19c2806f1abba9e72ad3c350073	5	NaN	Só achei ela pequena pra seis xícaras ,mais é um bom produto\r\n	2017-08-08 00:00:00	2017-08-08 23:26:23
5	bfc39df4f36c3693ff3b63fcbea9e90a	53904ddbea91e1e92b2b3f1d09a7af86	delivered	2017-10-23 23:26:46	2017-10-25 02:14:11	2017-10-27 16:48:46	2017-11-07 18:04:59	2017-11-13 00:00:00	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-31 02:14:11	29.99	14.10	9350	maua	SP	e781fdcc107d13d865fc7698711cc572	88032	florianopolis	SC	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	1	boleto	1	44.09	housewares	-27.536913	-48.509018	-23.680114	-46.452454	1bafb430e498b939f258b9c9dbdff9b1	3	NaN	NaN	2017-11-08 00:00:00	2017-11-10 19:52:38
6	5f49f31e537f8f1a496454b48edbe34d	a7260a6ccba78544ccfaf43f920b7240	delivered	2017-08-24 11:31:28	2017-08-24 11:45:25	2017-08-25 14:17:55	2017-08-28 20:12:20	2017-09-14 00:00:00	2	be03d93320192443b8fa24c0ca6ead98	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-30 11:45:25	46.80	67.70	9350	maua	SP	7a1de9bde89aedca8c5fbad489c5571c	1315	sao paulo	SP	utilidades_domesticas	59.0	189.0	3.0	775.0	16.0	16.0	13.0	1	credit_card	1	127.45	housewares	-23.552593	-46.640683	-23.680114	-46.452454	8899ca945efd951c97107b4966289227	1	NaN	Prezados que porcaria de atendimento ao cliente não se consegue falar com um atendente, só uma máquina burra e ignorante.\r\nVocês não me enviaram o kit de vedação da cafeteira e o filtro e se só isso n	2017-08-29 00:00:00	2017-08-30 02:26:02
7	5f49f31e537f8f1a496454b48edbe34d	a7260a6ccba78544ccfaf43f920b7240	delivered	2017-08-24 11:31:28	2017-08-24 11:45:25	2017-08-25 14:17:55	2017-08-28 20:12:20	2017-09-14 00:00:00	1	d4a3b5aa064bf44e74f1e71862bea22a	57c764b4a836300be881e2ff86e449f9	2017-08-30 11:45:25	9.90	3.05	14021	ribeirao preto	SP	7a1de9bde89aedca8c5fbad489c5571c	1315	sao paulo	SP	utilidades_domesticas	59.0	236.0	1.0	100.0	21.0	9.0	13.0	1	credit_card	1	127.45	housewares	-23.552593	-46.640683	-21.212279	-47.788152	8899ca945efd951c97107b4966289227	1	NaN	Prezados que porcaria de atendimento ao cliente não se consegue falar com um atendente, só uma máquina burra e ignorante.\r\nVocês não me enviaram o kit de vedação da cafeteira e o filtro e se só isso n	2017-08-29 00:00:00	2017-08-30 02:26:02
8	1fa40f202d5d233b6491e976c557b822	50fd5707c28d0a64dc20d67f937dd9ba	delivered	2017-09-23 22:11:10	2017-09-23 22:25:11	2017-09-26 17:27:54	2017-10-19 21:09:21	2017-11-13 00:00:00	1	8415b1dae10d2dcb36beec370c6a90cd	3504c0cb71d7fa48d967e0e4c94d59d9	2017-09-27 22:25:11	28.90	21.15	9350	maua	SP	35c6ec4630637b3ec0da6e587f245f83	69043	manaus	AM	utilidades_domesticas	59.0	322.0	5.0	600.0	24.0	5.0	18.0	1	credit_card	1	50.05	housewares	-3.076345	-59.936005	-23.680114	-46.452454	4b70092fc12f2328972d5ff1022d87e9	4	NaN	NaN	2017-10-20 00:00:00	2017-10-23 04:13:41
9	41c045db2d1876be9f05cf4a787693b2	a286f46d6e54cc0179bbb0ee07b0df5e	delivered	2017-08-16 14:06:30	2017-08-16 14:55:20	2017-08-18 15:41:40	2017-08-21 15:05:13	2017-08-29 00:00:00	1	5e18248fc768bdb7fc69fd012068d109	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-22 14:55:20	24.90	7.78	9350	maua	SP	4e4fa2b85379e9db6dc59f873f0a9748	5640	sao paulo	SP	utilidades_domesticas	37.0	749.0	4.0	600.0	16.0	6.0	20.0	1	credit_card	1	32.68	housewares	-23.627053	-46.736376	-23.680114	-46.452454	b9e086024ceb0234e5950016497a4928	5	NaN	NaN	2017-08-22 00:00:00	2017-08-26 02:31:53

Last rows

	order_id	customer_id	order_status	order_purchase_timestamp	order_approved_at	order_delivered_carrier_date	order_delivered_customer_date	order_estimated_delivery_date	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	seller_zip_code_prefix	seller_city	seller_state	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	payment_sequential	payment_type	payment_installments	payment_value	product_category_name_english	geolocation_lat_customer	geolocation_lng_customer	geolocation_lat_seller	geolocation_lng_seller	review_id	review_score	review_comment_title	review_comment_message	review_creation_date	review_answer_timestamp
115027	8dde389ebcf87898f96614bf718a3424	7f9a771719afa6802825b9f0793d980f	delivered	2018-08-14 10:41:49	2018-08-14 10:50:16	2018-08-22 08:00:00	2018-08-28 19:39:37	2018-09-05 00:00:00	1	09c85a316aae843ab464c8c55d6f8b80	5f57db27027655e6c6a391601daa0258	2018-08-20 10:50:16	98.00	53.04	29138	viana	ES	acc0e3b063cb014e3ef92b08b5836bcf	75131	anapolis	GO	automotivo	25.0	728.0	1.0	850.0	25.0	25.0	25.0	1	credit_card	10	151.04	auto	-16.374258	-48.978557	-20.371678	-40.420102	d41fb2b7b7606e0bc39eddd56dea3bea	5	NaN	NaN	2018-08-29 00:00:00	2018-08-30 09:42:55
115028	ac284fb15053d666dfb6128354f0e662	7a4e42927347804cbbc5b584d003bef6	delivered	2018-08-22 14:14:50	2018-08-22 14:25:19	2018-08-22 13:46:00	2018-08-28 21:32:27	2018-09-14 00:00:00	1	cde7eb02af6868b9904f1ea2c7fdfdc3	b19c48688808720822399ffa9f2dbe2f	2018-08-28 14:25:19	959.99	24.82	4801	sao paulo	SP	7f7e4fd22c2dd6ef9fdbf6431a6878a0	29936	sao mateus	ES	relogios_presentes	56.0	398.0	3.0	500.0	20.0	30.0	20.0	1	credit_card	8	984.81	watches_gifts	-18.730463	-39.845664	-23.713324	-46.698514	67094d46bcdebac20f73bdac807c9bac	5	NaN	NaN	2018-08-29 00:00:00	2018-08-30 14:13:03
115029	f2d6c25c24dec1cb1f8eeba2203634b5	57244724368844b9ccf59f216d2bb822	delivered	2018-08-12 20:58:54	2018-08-12 21:15:11	2018-08-13 15:25:00	2018-08-24 17:38:34	2018-09-12 00:00:00	1	73dacc49330dc5cc9b1c1983c16200e7	ccbd753e6863fe7314dc6c0ca5a074e7	2018-08-16 21:15:11	495.00	101.56	89046	blumenau	SC	74da9bfeaa1c29dc1e5b3a07a4ec17a2	58410	campina grande	PB	automotivo	54.0	299.0	1.0	5450.0	40.0	16.0	30.0	1	credit_card	6	596.56	auto	-7.241552	-35.882677	-26.922717	-49.148206	d71d9f67138ec03bfc0a7e6ccfd6046c	4	Muito bom	NaN	2018-08-25 00:00:00	2018-08-27 03:05:19
115030	3cd99c2644261f4b3bf7f70f67e4b5f2	d9ef74a91ad65ba313ff15f78c65159d	delivered	2017-10-20 08:49:05	2017-10-20 09:06:10	2017-10-23 14:23:55	2017-11-11 14:04:56	2017-11-22 00:00:00	1	e058c61cf68327217d4bc8b13d07cd64	fa8d335d68129e464e60c1826a683e96	2017-10-26 09:06:10	139.90	34.78	95660	tres coroas	RS	fd358179adc6171c9c6c51e0d91e6b68	70845	brasilia	DF	automotivo	37.0	2036.0	1.0	600.0	17.0	10.0	24.0	1	credit_card	10	174.68	auto	-15.774459	-47.876779	-29.517802	-50.765754	395474ca46cc360bedc6e58ebc585c4a	4	NaN	NaN	2017-11-12 00:00:00	2017-11-13 13:06:51
115031	8cca5f9f04056cb2d8abb9b845e89b62	7573237856d19beef367370dd2285f37	delivered	2018-05-12 07:21:13	2018-05-12 07:35:42	2018-05-14 14:59:00	2018-05-18 20:44:31	2018-06-04 00:00:00	1	2307240c5347bb41a709a1ab8e38b5ff	2c538755f1ca9540af144f266e70df6c	2018-05-17 07:35:12	334.99	24.92	39801	castro pires	MG	077c6658adbb60fcf8437e255c00e906	12095	taubate	SP	automotivo	57.0	372.0	4.0	2150.0	28.0	28.0	38.0	1	credit_card	6	359.91	auto	-23.075220	-45.538807	-17.851690	-41.493610	1a6fe9277fca69b72022e71be4833f36	5	NaN	NaN	2018-05-19 00:00:00	2018-05-20 16:21:35
115032	a37e262a26000281d0ade3b4eb1ce1e6	d0602b514179e7ed50e801cc02769bac	delivered	2018-08-06 23:14:27	2018-08-06 23:25:19	2018-08-07 14:16:00	2018-08-13 19:08:40	2018-08-22 00:00:00	1	987ae6d6e94a608f9ea32bc82a649470	466222e777149751370e7e98fb623b0c	2018-08-08 23:25:19	87.90	17.55	20931	rio de janeiro	RJ	ce05c653348a8e630ebbb1fd1e0968d2	74080	goiania	GO	automotivo	60.0	1469.0	4.0	550.0	36.0	8.0	15.0	1	credit_card	10	105.45	auto	-16.689245	-49.259284	-22.876270	-43.212926	bf0ab4c039d6b05f116d3b9a97344e09	5	NaN	NaN	2018-08-14 00:00:00	2018-08-15 10:33:03
115033	8edaa376e19d08bc84ab8845682216b4	4c1e29ec2ed2feac441cf24b25262ed2	delivered	2018-04-24 08:37:20	2018-04-24 17:26:25	2018-04-25 12:24:00	2018-05-10 22:36:37	2018-05-14 00:00:00	1	b0498e44190727b728ae4490f2e9b6a5	dda37071807e404c5bb2a1590c66326f	2018-04-30 09:30:37	199.99	19.28	3282	sao paulo	SP	913a4e0cb7fe555e6cffa875ecd58e2e	28455	sao jose de uba	RJ	malas_acessorios	25.0	712.0	4.0	5250.0	34.0	23.0	40.0	1	credit_card	1	219.27	luggage_accessories	-21.358247	-41.941457	-23.590854	-46.541398	7bbe7636141510158aa577dcfd017b13	5	NaN	NaN	2018-05-11 00:00:00	2018-05-13 00:12:43
115034	e9f8c67129c6f0bf411b428141ddfbf5	b364fc9218a7e1ddd9eb23124ebb7d86	delivered	2017-04-11 22:09:31	2017-04-12 13:10:17	2017-04-17 10:26:59	2017-04-30 06:57:43	2017-05-12 00:00:00	1	ecb624b552f939e58c7881de58ece085	0936e1837d0c79253456bbb2ffaaef10	2017-04-26 13:10:17	19.45	15.56	2050	sao paulo	SP	11d76022677f3753f19633e2fd0470c3	35995	sao domingos do prata	MG	ferramentas_jardim	57.0	314.0	1.0	900.0	62.0	3.0	13.0	1	credit_card	7	70.02	garden_tools	-19.871369	-42.960859	-23.516544	-46.610563	95df327760017d154c5f6364e06d70eb	5	NaN	NaN	2017-05-01 00:00:00	2017-05-03 16:38:56
115035	e9f8c67129c6f0bf411b428141ddfbf5	b364fc9218a7e1ddd9eb23124ebb7d86	delivered	2017-04-11 22:09:31	2017-04-12 13:10:17	2017-04-17 10:26:59	2017-04-30 06:57:43	2017-05-12 00:00:00	2	ecb624b552f939e58c7881de58ece085	0936e1837d0c79253456bbb2ffaaef10	2017-04-26 13:10:17	19.45	15.56	2050	sao paulo	SP	11d76022677f3753f19633e2fd0470c3	35995	sao domingos do prata	MG	ferramentas_jardim	57.0	314.0	1.0	900.0	62.0	3.0	13.0	1	credit_card	7	70.02	garden_tools	-19.871369	-42.960859	-23.516544	-46.610563	95df327760017d154c5f6364e06d70eb	5	NaN	NaN	2017-05-01 00:00:00	2017-05-03 16:38:56
115036	815ba48fd172b6a71f09180c118a31ca	626da291c796ef2695981deb0bbc9eed	processing	2017-09-15 13:24:29	2017-09-16 03:06:14	NaN	NaN	2017-10-09 00:00:00	1	41f9d5d764dc0fa4928c9177275e5763	5aaa890629f83706d8d9bfecd8377c1c	2017-09-21 03:06:14	48.90	17.92	25720	petropolis	RJ	2dad8f2b565b14983d2792369429b34f	95950	nova brescia	RS	construcao_ferramentas_construcao	42.0	251.0	1.0	400.0	16.0	16.0	16.0	1	boleto	1	66.82	construction_tools_construction	-29.213983	-52.031601	-22.436244	-43.140338	3f93f4f7f09c312dce86e2fb8a4d4430	1	NaN	NaN	2017-10-12 00:00:00	2017-10-14 03:44:41

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category